global root_dir = "`1'"

include "$root_dir/code/config/config.do"

cap noi log using ${log_dir}/table_6_placebo_pauto90.log, replace name(tabl)

capture noi {

	do ${code_dir}/config/tabletools.do

	
	global depvar pauto90
	global ttt "bia"

	use ${final_dir}/regression_dataset_from1970_tfacit1.dta, clear

	* restrict to baseline reg firms (based on auto95 as depvar)
	mmerge BvD using ${final_dir}/bvd_list_regfirms_auto95.dta, unmatched(master)
	keep if _m == 3


	tab year, gen(YY_)

	estimates clear
	clonevar LSW = lswMPm_1995_a
	clonevar HSW = hswMPm_1995_a
	clonevar VAEMP = vaempMPm_1995_a
	clonevar GDPGAP = lngdpgap_1995_a
	clonevar GDPPC = gdppcMPm_1995_a

	
	clonevar stockown = k${depvar}_${ttt} 
	clonevar stockownzero = k${depvar}_${ttt}0  
	clonevar stockother = kNOT_${depvar}_${ttt} 
	clonevar stockotherzero = kNOT_${depvar}_${ttt}0
	clonevar spilloversown = spill${depvar}${ttt}_1995_a
	clonevar spilloversother = spillN${depvar}${ttt}_1995_a
	clonevar spilloversownzero = spill${depvar}${ttt}_1995_a0
	clonevar spilloversotherzero = spillN${depvar}${ttt}_1995_a0
	

	bys lse_id : egen _t_${depvar}_${ttt}_95 = sum(${depvar}_${ttt}) if year>=1995+2 & year <= 2009+2
	bys lse_id : egen t_${depvar}_${ttt}_95 = max(_t_${depvar}_${ttt}_95)
	drop _t_${depvar}_${ttt}_95
	sort lse_id year
	egen yearctry = group(year country_shr_1995) if year <= 2009
	egen yearindustry = group(year industry) if year <= 2009
	egen yearctryindustry = group(year industry country_shr_1995) if year <= 2009

	* 1) GDPGAP | F+IY
	ppmlhdfe F2.${depvar}_${ttt} LSW HSW GDPGAP stockown stockownzero stockother stockotherzero spilloversown spilloversownzero spilloversother spilloversotherzero if year>=1995 & maxweight_1995 < 1 & missing_weights_1995==0 & missing_spill_weights_1995 == 0 & t_${depvar}_${ttt}_95>0, vce(cluster lse_id) absorb(lse_id yearindustry)
	estadd local f "\yes"
	estadd local iy "\yes"
	estadd local cy "\no"
	estadd local obs "{\num{`e(N)'}}"
	estadd local firms "{\num{`e(N_clust)'}}"
	estimates store col_1
	* 2) GDPGAP + VAEMP | F+IY
	ppmlhdfe F2.${depvar}_${ttt} LSW HSW GDPGAP VAEMP stockown stockownzero stockother stockotherzero spilloversown spilloversownzero spilloversother spilloversotherzero if year>=1995 & maxweight_1995 < 1 & missing_weights_1995==0 & missing_spill_weights_1995 == 0 & t_${depvar}_${ttt}_95>0, vce(cluster lse_id)  absorb(lse_id yearindustry)
	estadd local f "\yes"
	estadd local iy "\yes"
	estadd local cy "\no"
	estadd local obs "{\num{`e(N)'}}"
	estadd local firms "{\num{`e(N_clust)'}}"
	estimates store col_2
	* 3) GDPGAP + GDPPC | F+IY
	ppmlhdfe F2.${depvar}_${ttt} LSW HSW GDPGAP GDPPC stockown stockownzero stockother stockotherzero spilloversown spilloversownzero spilloversother spilloversotherzero if year>=1995 & maxweight_1995 < 1 & missing_weights_1995==0 & missing_spill_weights_1995 == 0 & t_${depvar}_${ttt}_95>0, vce(cluster lse_id)  absorb(lse_id yearindustry)
	estadd local f "\yes"
	estadd local iy "\yes"
	estadd local cy "\no"
	estadd local obs "{\num{`e(N)'}}"
	estadd local firms "{\num{`e(N_clust)'}}"
	estimates store col_3
	* 4) GDPGAP | F+IY+CY
	ppmlhdfe F2.${depvar}_${ttt} LSW HSW GDPGAP stockown stockownzero stockother stockotherzero spilloversown spilloversownzero spilloversother spilloversotherzero if year>=1995 & maxweight_1995 < 1 & missing_weights_1995==0 & missing_spill_weights_1995 == 0 & t_${depvar}_${ttt}_95>0, vce(cluster lse_id) absorb(lse_id yearindustry yearctry)
	estadd local f "\yes"
	estadd local iy "\yes"
	estadd local cy "\yes"
	estadd local obs "{\num{`e(N)'}}"
	estadd local firms "{\num{`e(N_clust)'}}"
	estimates store col_4
	* 5) GDPGAP + VAEMP | F+IY+CY
	ppmlhdfe F2.${depvar}_${ttt} LSW HSW GDPGAP VAEMP stockown stockownzero stockother stockotherzero spilloversown spilloversownzero spilloversother spilloversotherzero if year>=1995 & maxweight_1995 < 1 & missing_weights_1995==0 & missing_spill_weights_1995 == 0 & t_${depvar}_${ttt}_95>0, vce(cluster lse_id) absorb(lse_id yearindustry yearctry)
	estadd local f "\yes"
	estadd local iy "\yes"
	estadd local cy "\yes"
	estadd local obs "{\num{`e(N)'}}"
	estadd local firms "{\num{`e(N_clust)'}}"
	estimates store col_5
	* 6) GDPGAP + GDPPC | F+IY+CY
	ppmlhdfe F2.${depvar}_${ttt} LSW HSW GDPGAP GDPPC stockown stockownzero stockother stockotherzero spilloversown spilloversownzero spilloversother spilloversotherzero if year>=1995 & maxweight_1995 < 1 & missing_weights_1995==0 & missing_spill_weights_1995 == 0 & t_${depvar}_${ttt}_95>0, vce(cluster lse_id) absorb(lse_id yearindustry yearctry)
	estadd local f "\yes"
	estadd local iy "\yes"
	estadd local cy "\yes"
	estadd local obs "{\num{`e(N)'}}"
	estadd local firms "{\num{`e(N_clust)'}}"
	estimates store col_6	

	drop LSW HSW GDPGAP GDPPC VAEMP

	clonevar GDPPC_foreign = gdppcMPm_shr4_foreign_1995_a
	clonevar VAEMP_foreign = vaempMPm_shr4_foreign_1995_a
	clonevar GDPgap_foreign = lngdpgap_shr_foreign_1995_a
	clonevar LSW_foreign = lswMPm_shr4_foreign_1995_a
	clonevar HSW_foreign = hswMPm_shr4_foreign_1995_a
	* 7) GDPGAP | F+IY+CY | foreign
	ppmlhdfe F2.${depvar}_${ttt} LSW_foreign HSW_foreign GDPgap_foreign stockown stockownzero stockother stockotherzero spilloversown spilloversownzero spilloversother spilloversotherzero if year>=1995 & maxweight_1995 < 1 & missing_weights_1995==0 & missing_spill_weights_1995 == 0 & t_${depvar}_${ttt}_95>0, vce(cluster lse_id)  absorb(lse_id yearindustry yearctry)
	estadd local f "\yes"
	estadd local iy "\yes"
	estadd local cy "\yes"
	estadd local obs "{\num{`e(N)'}}"
	estadd local firms "{\num{`e(N_clust)'}}"
	estimates store col_7
	* 8) GDPGAP + VAEMP | F+IY+CY | foreign
	ppmlhdfe F2.${depvar}_${ttt} LSW_foreign HSW_foreign GDPgap_foreign VAEMP_foreign stockown stockownzero stockother stockotherzero spilloversown spilloversownzero spilloversother spilloversotherzero if year>=1995 & maxweight_1995 < 1 & missing_weights_1995==0 & missing_spill_weights_1995 == 0 & t_${depvar}_${ttt}_95>0, vce(cluster lse_id)  absorb(lse_id yearindustry yearctry)
	estadd local f "\yes"
	estadd local iy "\yes"
	estadd local cy "\yes"
	estadd local obs "{\num{`e(N)'}}"
	estadd local firms "{\num{`e(N_clust)'}}"
	estimates store col_8
	* 9) GDPGAP + GDPPC | F+IY+CY | foreign
	ppmlhdfe F2.${depvar}_${ttt} LSW_foreign HSW_foreign GDPgap_foreign GDPPC_foreign stockown stockownzero stockother stockotherzero spilloversown spilloversownzero spilloversother spilloversotherzero if year>=1995 & maxweight_1995 < 1 & missing_weights_1995==0 & missing_spill_weights_1995 == 0 & t_${depvar}_${ttt}_95>0, vce(cluster lse_id)  absorb(lse_id yearindustry yearctry)
	estadd local f "\yes"
	estadd local iy "\yes"
	estadd local cy "\yes"
	estadd local obs "{\num{`e(N)'}}"
	estadd local firms "{\num{`e(N_clust)'}}"
	estimates store col_9	

	drop LSW_foreign HSW_foreign GDPgap_foreign GDPPC_foreign VAEMP_foreign
	drop spilloversown spilloversownzero spilloversother spilloversotherzero
	drop stockown stockownzero stockother stockotherzero

	setlabels, sname("own")

	dhoztab * using ${tab_dir}/main/Table_6_placebo_${depvar}.tex,b(%10.2f) se(%10.2f) nogaps nomtitles numbers nolines nonotes replace  showdepvarinfo sfmt(a1) scalars("f \noalign{\medskip} Firm fixed effects" "iy Industry \stimes year fixed effects" "cy Country \stimes year fixed effects" "obs \noalign{\medskip} Observations"  "firms Number of firms") label mgroups("Domestic and foreign" "Foreign", pattern(1 0 0 0 0 0 1 0 0) span prefix(\multicolumn{@span}{c}{) suffix(}) erepeat(\cmidrule(lr){@span})) drop(*zero _cons) noobs rename(LSW_foreign LSW HSW_foreign HSW GDPgap_foreign GDPGAP VAEMP_foreign VAEMP GDPPC_foreign GDPPC) depvar("Placebo machinery (pauto90)") order(LSW HSW GDPGAP VAEMP GDPPC stockown stockother spilloversown spilloversother) notes("This table replicates our baseline regressions using placebo machinery innovations. Placebo machinery are innovations in machinery excluding auto90, denoted pauto90. The sample is restricted to firms having done an auto95 innovation in the sample period. All columns include firm and industry-year fixed effects. Columns 4-9 add country-year fixed effects. In Columns 7--9, the macroeconomic variables are the normalized foreign variables as defined in the text. Spillover and stock variables are calculated with respect to the dependent variable (pauto90). Standard errors are clustered at firm-level and reported in parentheses.")

	*vscode shows the } in the command as wrong, but it works
}
if _rc == 0 {
    display "Execution finished successfully."
}
else {
    display "Execution finished with errors."
}

cap log close tabl